SUMMARY

• Over 7+ years of professional experience in Software Development Life Cycle (SDLC) and Systems Test, including design, implementation, integration, maintenance and testing of various web - based, Enterprise, Client/Server and Distributed applications using Python, Django and SQL.
• Experience working in Banking sector, Telecommunication sector, Retail and Financial sectors.
• Experience with Design, code, and debug operations, reporting, data analysis and web applications utilizing Python.
• Good Experience with Django, Python Web framework.
• Experienced in implementing Model View Control (MVC) architecture using server-side applications like Django for developing web applications.
• Experience analyzing very large, complex, multi-dimensional data sets and developing analytic solutions, experience in predictive analytics using Python.
• Excellent experience with Requests, NumPy, Matplotlib, SciPy, PySpark and Pandas - python libraries during development lifecycle and experience in developing APIs for the application using Python and Django.
• Experience in AWS Cloud platform and its features which include EC2, AMI, EBS Cloud watch, AWS Config, Auto - scaling, IAM user management, and AWS S3.
• Experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts.
• Experience in using object-relational mapper (ORM) library to automate the transfer of data stored in relational databases tables into objects.
• Good experience of Web Services with protocols SOAP and REST.
• Experienced in developing Web Services with Python programming language and Good working experience in processing large datasets with Spark using Pyspark.
• Extensive experience in creatingTables, Views, Indexes, Stored Procedures, Cursors, Triggers,and T-SQL queries.
• Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on MySQL and PostgreSQL database.
• Experience in methodologies like Waterfall Model and Agile Methodology (Scrum).
• Ability to learn and adapt quickly to the emerging new technologies and paradigms.
• Excellent interpersonal and communication skills, the ability to provide solutions from a functional and technical perspective, meet deadlines, quickly build client rapport and be a team player.
• Experience in billing/rating COTS products like Netcracker RBM, Mediation Zone, Openet FW.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica and DataStage.
• Expertise in using Excel functions and lookups for the Data Comparison and Data Validation.
• Excellent written and verbal communication interpersonal skills.

TECHNICAL SKILLS

Languages: Python 3.x/2.7, SQL

Frameworks: Django, Flask

Python Libraries: Numpy, Pandas, Matplotlib, Scipy, PySpark

IDE’s: Eclipse, PyCharm, PyDev, Spyder

Web Technologies: API, Automation Testing, Machine Learning

Web Services: REST, SOAP

Data Base: MS SQL, Server, Oracle 8i/9i, 10g/11g, SQL Developer, Cassandra, Teradata V2R6/V2R5, Postgres.

Methodologies: Agile, Waterfall

Operating Systems: Windows (All Variants), LINUX/UNIX

Business Intelligence tools: Cognos 10.2.2, Tableau 9.3, Power BI

Business analyst tools: Jira, Splunk, New Relic, Zenoss, Confluence, MS Vision, MS Office, SharePoint

Operating Systems: Unix, Linux, Windows

Basic tools: Eclipse, Weka, Anaconda, Jupyter, SecureCRT, SuperPutty, Mediation Zone, MS Office Suite

Other skills: Linux, Unix, ITIL, ACSS (Customer Care Service), POS (Point of Sales), Scrum, Agile & Waterfall, Progression and Regression Testing, SDLC, Manual Testing, functional Testing, Rating & Billing Process, Functional design and testing experience, Monitoring, Bug fixes, Incident Management.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Systems Engineer

Responsibilities:

• Team Lead and Point of contact for any troubleshooting issues, testing inconveniences, data setup.
• Gathering requirements for the test case scenarios, writing the test case scenarios, executing test cases.
• Involved in various phases of Software Development Life Cycle (SDLC) of the application like requirement gathering, Design, Analysis and Code development.
• Experience in developing tools required for implementation of automation tests and verification of same.
• Monitoring, profiling of applications and implementing compliance requirements in application servers and web servers as per security requirements.
• Collaborated with Automation Engineers and Quality Assurance teams and determined root cause of all issues on implementation of tests.
• Designed test scripts and test cases for automated network
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica and DataStage.
• Expertise in Testing complex Business rules by creating mapping and various transformations.
• Expertise in using Excel functions and lookups for the Data Comparison and Data Validation.
• Performing functional and regression testing.
• Performing Data setup in the test environment.
• Experience in Data replication and baseline testing.
• Experience with shakeout testing.
• Experience with testing deployments that go on to further release as enterprise release, maintenance release, break fixes, infrastructure release.
• Working on Voice Usage Migration testing.
• Coordinating with offshore teams in India for development testing and managing day to day activities
• Use of JIRA to create incidents, manage incidents, follow up on these incidents.
• Joining Bridge lines, providing timely updates, troubleshooting issues with production test data, vendor engagement.
• Use of SPLUNK and New Relic to monitor usage flow to downstream applications and teams, backlogs, graphs.
• Worked on TestLink tool for tracking and managing the test cases.
• Hands-on and extensive experience on Defect Life cycle tool - JIRA and AYS.
• Used Django framework to develop the application and used Python modules for web crawling.
• Used Django framework in developing web applications to implement the model view control architecture (MVC).
• Built various graphs for business decision making using Python library.
• Built various graphs for business decision making using Python library.
• Developed Python API's to dump the array structures in the Processor at the failure point for debugging.
• Designed Forms, Modules, Views and Templates using Django and Python.
• Used Python based GUI components for the front end functionality such as selection criteria.
• Worked with Python ORM Libraries utilizing Django ORM.
• Worked with NumPy, SciPy, Matplotlib, and Pandas - python libraries during development lifecycle
• Wrote Python scripts to parse XML documents and load the data in database.
• Utilized PyUnit, the Python Unit test framework, for all Python applications and used Django Database API's to access database objects.
• Involved in doing AGILE(SCRUM) practices and planning of sprint attending daily agile (SCRUM) meetings andSPRINTretrospective meetings to produce quality deliverables within time.
• Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation.

Confidential, Irving, TX

Quality Assurance

Responsibilities:

• Worked on 5G Projects.
• Worked on testing the rating and billing environment for SMS, Data and Voice.
• Worked on ACSS (Customer Care Tool), POS (Point of Sales), and Confidential 5G Home Website Testing.
• Worked on Automation Testing and developed automated test cases while conducting manual testing to ensure software quality and timely delivery.
• Analyzed business requirements and user experience goals and wrote test scenarios and test cases and executed those.
• Reviewed programming code for errors, resolving 200+ bugs prior to product launch.
• In a Scrum environment, suggested new workflow processes to improve the SDLC process and increased testing turnaround by 15%
• Performed quality reviews of design documentation to ensure compliance with project plan scope and requirements.
• Identified, replicated, and resolved 200+ errors during the development process, improving software quality and end-user experience.
• Collaborated with product managers and development teams to address software issues, quickly resulting in a 90% customer satisfaction rating.
• Participated in Agile sprint planning and coordinated individual and team testing throughout to ensure quality deliverables by the end of the sprint.
• Executed various testing methods such as black box, functional, regression and user acceptance testing to validate requirements are met.
• Trained new testers on creating and documenting defects in JIRA, testing, configuring mobile devices and supported team during testing.
• Performed documentation of important scripts and knowledge transfer in Confluence Pages.
• Created defects for issues and blockages encountered during testing phase in JIRA and worked and daily followed up with developers to get those defects resolved.
• Involved in functional designing and testing, gathered functional requirements and presented to my team in a better understandable way with proper user stories for them to deliver the output.
• Created, documented and maintained technical/functional manuals to reduce the training time for new testers.
• Provided feedback and recommendations to developers on website and software usability and functionality.
• Provided guidance to a team of three junior QA Analysts working on mobile website launches.

Confidential, Chicago, IL

BI Developer

Responsibilities:

• Deployed Business Intelligence (BI) with Cognos 10 reporting system and tools.
• Developed and modified Cognos Framework Manager Models and packages.
• Developing Interactive BI reports, Active, and Business Insight dashboards (Work Space).
• Analyzed and gathered business requirements specifications by interacting with client and understanding business requirement specification documents.
• Worked with ETL team by Performing Impact Analysis of the changes done to the existing mappings and provided the feedback.
• Provided SME reports for multiple projects.
• Collaborated with both customers and development group to document business requirements
• Worked on large databases and did statistical analysis.
• Customized Reports by writing complex custom SQL queries.
• Tools: Rave Visualizations, experience with Visualization Customizer.
• Optimize report distribution, execution and the scalability of all reporting solutions so they are autonomous and dynamic
• Work with the Data Management team to provide input on logical and physical database design, data modeling and/or mapping.
• Developed SQL Queries, Views and Stored Procedures.
• Translated project requirements into functional and non-functional specifications for BI reports and applications.
• Utilized and established programming, testing and release standards. Participate in the refinement and maintenance of current standards and the establishment of new standards.
• Worked on a POC using Tableau on an alternate Server per user requirement.
• Projects: Performance POC, migrate report studio dashboards to Business Insights, Active Reports.

Confidential, Schaumburg, IL

BI Developer

Responsibilities:

• Developed and modified Cognos Framework Manager Models and packages to satisfy information requirements.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Worked with ETL team by Performing Impact Analysis of the changes done to the existing mappings and provided the feedback.
• Designed and developed the Framework Manager models and published into the Cognos Connection.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Worked on POC using SSRS and SSIS.
• Customized Reports by writing complex custom SQL queries.
• Experience of Data Warehousing with MS SQL server 2005 SSIS, Transact SQL
• Highly efficient performance in Power cube generation using Cognos Transformer.
• Extensive Financial and Insurance background with great experience in Complex Reporting.
• Followed AGILE development methodology to develop the application.
• Actively handled multiple priority tasks in parallel and participated in review of project deliverables.

Confidential, Plano TX

BI Developer

Responsibilities:

• Interact with the users and stakeholders to gather user requirements and their expectations from the system.
• Involve in gathering feedbacks in existing application.
• Prepare BRD and then converted these requirements into FRS.
• Involve in Analyzing Business Requirements and developing SRS.
• Designed and developed the Framework Manager models and published into the Cognos Connection.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Customized Reports by writing complex custom SQL queries.
• MS Visio to develop UML diagrams such as activity diagram, data flow diagram, and use case diagram.
• Design UI of the application. Conduct conference call with project team.
• Communicate updates corrective actions with the project manager, project lead, developers, and QA and stake holders.
• Analyze monthly/quarterly performance against plans and forecast.
• Collaborated with both customers and development group to document business requirements.
• Provided SME reports for multiple projects.
• Conduct GAP Analysis, Cost-Benefit Analysis and Business Impact Analysis.
• Developed new and maintained the existing Cognos BI reporting solutions.
• Perform Data Validation, error checking, troubleshooting and performance tuning.
• Create and/or maintain Cognos 10 Framework Manager Metadata models to deliver robust and secure foundation for report development.
• Developed over 19 complex reports for our Financial department.
• Fixed more than 150 Existing Reports which had any kind of underlying SQL errors in them
• Dealing simultaneously with multiple Cognos Servers which internally had over 12 folder structures inside it which represented various departments and functional areas of our business.
• Worked on diagnosis of reports and reworked the queries for atleast 50 complicated reports which failed in Cognos 10 due to thestrict Relational SQL rule implementationfrom the previous versions of Cognos.
• Provided usage and performance metrics by continuously monitoring the Cognos environment.

Confidential, Addison TX

Quality Assurance Analyst

Responsibilities:

• Worked as a QA analyst on Customer Offers and Targeting team to document, develop and execute manual test cases.
• Responsible for SDLC process in gathering requirements, system analysis, design, development, testing and deployment.
• Team lead (POC lead) for the project.
• Worked with developers, business partners, stakeholders to determine optimal results.
• Review and analyze user stories to determine reasonability, testability, resource requirements and sequencing.
• Provide work estimates for testing User stories.
• Analyzed requirements, developed test strategies, created test cases, executed test cases.
• Identify and raise risks as early as possible in SDLC.
• Create test data as required to test.
• Created incidents, tracked these incidents. Followed up with developers on these incidents and made sure there were bug fixes and resolution attained for these incidents.
• Identify and log defects in JIRA to resolve and verify fixes when implemented.
• Participate in the identification and implementation of continuous improvement in process and standards for the entire team.
• Assisted the Scrum team to enable testing of application so as to make sure that business, functional and technical requirements were met sprint over sprint.
• Maintained and made sure work was completed within the times framed SLA’s.
• Expertise with User Interface (UI) Testing.
• Worked on Database Testing using SQL server and Oracle.
• Provided Knowledge Transfer to new team members.